Oracle
lateral join 标签描述

示例 造测试数据 SQL>createtabledbmt.tobj1asselectfromdba_objectswhereobject_typeLIKE'TABLE%'andrownum<10000; Tablecreated SQL>createtabledbmt.tobj2asselectfromdbmt.tobj1; Tablecreated. 执行改写前测试SQL ---测试SQL,改写前 altersessionsetstatistics_level=all; selecta.owner,a.object_name,a.created, (select...